<!DOCTYPE html> 
<html lang="en"> 
<head> 
    <meta charset="UTF-8"> 
    <title>Title</title> 
    <style> 
        body{line-height: 34px;} 
        .tableList,.tableInfo{width: 1200px;margin: 60px auto;} 
        h1{text-align: center;} 
        table{font-size: 13px;color: #0072BF;border-radius: 15px;text-align: left; 
            color: rgba(0,0,0,.87);border-collapse: collapse;border-spacing: 0px;background: #ffffff;width: 100%;table-layout: fixed; 
         } 
        thead{vertical-align: middle;border-color: inherit;background-color: #cce2ff;} 
        td,th{overflow: hidden;white-space: nowrap;text-overflow: ellipsis;border: 1px solid #e8e9e9;padding-left:6px;} 
        tr:hover{background:#f1f4f8;} 
        .tableList tr{cursor: pointer;} 
        .backHome{color: dodgerblue;text-decoration: underline;cursor: pointer;} 
        .tableInfo{display: none;} 
    </style> 
</head> 
<body> 
    <div class="tableList"> 
        <h1>数据库名称：imall</h1> 
        <div> 
            <h3 onclick="backToHome">目录</h3> 
            <table> 
                <thead> 
                    <th style="width:7%;">序号</th> 
                    <th style="width:20%;">表名</th> 
                    <th style="width:63%;">注释</th> 
                    <th style="width:10%;">记录条数</th> 
                </thead> 
                <tbody> 
                <tr onclick="queryInfo('m_member')" class="m_member" >   
                    <td>1</td> 
                    <td>m_member</td> 
                    <td>会员信息表</td> 
                    <td>4</td> 
                </tr> 
                <tr onclick="queryInfo('m_member_level')" class="m_member_level" >   
                    <td>2</td> 
                    <td>m_member_level</td> 
                    <td>会员等级信息表</td> 
                    <td>4</td> 
                </tr> 
                <tr onclick="queryInfo('oms_aftersale')" class="oms_aftersale" >   
                    <td>3</td> 
                    <td>oms_aftersale</td> 
                    <td>订单售后</td> 
                    <td>0</td> 
                </tr> 
                <tr onclick="queryInfo('oms_aftersale_item')" class="oms_aftersale_item" >   
                    <td>4</td> 
                    <td>oms_aftersale_item</td> 
                    <td>订单售后</td> 
                    <td>0</td> 
                </tr> 
                <tr onclick="queryInfo('oms_order')" class="oms_order" >   
                    <td>5</td> 
                    <td>oms_order</td> 
                    <td>订单表</td> 
                    <td>0</td> 
                </tr> 
                <tr onclick="queryInfo('oms_order_delivery_history')" class="oms_order_delivery_history" >   
                    <td>6</td> 
                    <td>oms_order_delivery_history</td> 
                    <td>订单发货记录</td> 
                    <td>0</td> 
                </tr> 
                <tr onclick="queryInfo('oms_order_item')" class="oms_order_item" >   
                    <td>7</td> 
                    <td>oms_order_item</td> 
                    <td>订单中所包含的商品</td> 
                    <td>0</td> 
                </tr> 
                <tr onclick="queryInfo('oms_order_operate_history')" class="oms_order_operate_history" >   
                    <td>8</td> 
                    <td>oms_order_operate_history</td> 
                    <td>订单操作历史记录</td> 
                    <td>0</td> 
                </tr> 
                <tr onclick="queryInfo('oms_wechat_payment_history')" class="oms_wechat_payment_history" >   
                    <td>9</td> 
                    <td>oms_wechat_payment_history</td> 
                    <td>微信订单表</td> 
                    <td>0</td> 
                </tr> 
                <tr onclick="queryInfo('p_brand')" class="p_brand" >   
                    <td>10</td> 
                    <td>p_brand</td> 
                    <td>商品品牌信息表</td> 
                    <td>7</td> 
                </tr> 
                <tr onclick="queryInfo('p_product')" class="p_product" >   
                    <td>11</td> 
                    <td>p_product</td> 
                    <td>商品信息表</td> 
                    <td>5</td> 
                </tr> 
                <tr onclick="queryInfo('p_product_attribute_key')" class="p_product_attribute_key" >   
                    <td>12</td> 
                    <td>p_product_attribute_key</td> 
                    <td>商品属性信息表</td> 
                    <td>14</td> 
                </tr> 
                <tr onclick="queryInfo('p_product_attribute_sku')" class="p_product_attribute_sku" >   
                    <td>13</td> 
                    <td>p_product_attribute_sku</td> 
                    <td>商品属性规格价格表</td> 
                    <td>3</td> 
                </tr> 
                <tr onclick="queryInfo('p_product_attribute_type')" class="p_product_attribute_type" >   
                    <td>14</td> 
                    <td>p_product_attribute_type</td> 
                    <td>商品属性类别</td> 
                    <td>28</td> 
                </tr> 
                <tr onclick="queryInfo('p_product_attribute_value')" class="p_product_attribute_value" >   
                    <td>15</td> 
                    <td>p_product_attribute_value</td> 
                    <td>商品属性值信息表</td> 
                    <td>8</td> 
                </tr> 
                <tr onclick="queryInfo('p_product_category')" class="p_product_category" >   
                    <td>16</td> 
                    <td>p_product_category</td> 
                    <td>商品分类信息表</td> 
                    <td>26</td> 
                </tr> 
                <tr onclick="queryInfo('p_product_member_price')" class="p_product_member_price" >   
                    <td>17</td> 
                    <td>p_product_member_price</td> 
                    <td>商品会员价格信息表</td> 
                    <td>12</td> 
                </tr> 
                <tr onclick="queryInfo('p_product_sku_stock')" class="p_product_sku_stock" >   
                    <td>18</td> 
                    <td>p_product_sku_stock</td> 
                    <td>商品sku库存信息表</td> 
                    <td>9</td> 
                </tr> 
                </tbody> 
            </table> 
        </div> 
    </div> 
    <div class="tableInfo" id="m_member"> 
        <h1>表名：m_member</h1> 
        <div> 
            <h3>表的注释：</h3> 
            <pre>会员信息表</pre> 
            <h3 class="backHome" onclick="backToHome()">返回目录</h3> 
            <table> 
                <thead> 
                    <th style="width:18%;">字段</th> 
                    <th style="width:8%;">类型</th> 
                    <th style="width:8%;">字段长度</th> 
                    <th style="width:60%;">注释</th> 
                    <th style="width:6%;">是否为空</th> 
                </thead> 
                <tbody> 
                <tr> 
                    <td>id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>id</td> 
                    <td>NO</td> 
                </tr> 
                <tr> 
                    <td>birthday</td> 
                    <td>date</td> 
                    <td>null</td> 
                    <td>生日</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>city</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>所在城市</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>gender</td> 
                    <td>int</td> 
                    <td>null</td> 
                    <td>性别：0->未知；1->男；2->女</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>icon</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>头像</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>member_level_id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>会员等级ID</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>nickname</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>昵称</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>password</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>密码</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>personalized_signature</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>个性签名</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>phone</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>手机号码</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>register_time</td> 
                    <td>datetime</td> 
                    <td>null</td> 
                    <td>注册时间</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>status</td> 
                    <td>int</td> 
                    <td>null</td> 
                    <td>帐号启用状态:0->禁用；1->启用</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>username</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>用户名</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>create_by</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>创建者</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>create_time</td> 
                    <td>datetime</td> 
                    <td>null</td> 
                    <td>创建时间</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>remark</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>备注</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>search_value</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>搜索值</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>tenant_id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>租户ID</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>update_by</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>更新者</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>update_time</td> 
                    <td>datetime</td> 
                    <td>null</td> 
                    <td>更新时间</td> 
                    <td>YES</td> 
                </tr> 
                </tbody> 
            </table> 
        </div> 
    </div> 
    <div class="tableInfo" id="m_member_level"> 
        <h1>表名：m_member_level</h1> 
        <div> 
            <h3>表的注释：</h3> 
            <pre>会员等级信息表</pre> 
            <h3 class="backHome" onclick="backToHome()">返回目录</h3> 
            <table> 
                <thead> 
                    <th style="width:18%;">字段</th> 
                    <th style="width:8%;">类型</th> 
                    <th style="width:8%;">字段长度</th> 
                    <th style="width:60%;">注释</th> 
                    <th style="width:6%;">是否为空</th> 
                </thead> 
                <tbody> 
                <tr> 
                    <td>id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>id</td> 
                    <td>NO</td> 
                </tr> 
                <tr> 
                    <td>name</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>会员等级名称</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>discount</td> 
                    <td>decimal</td> 
                    <td>null</td> 
                    <td>折扣</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>create_by</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>创建者</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>create_time</td> 
                    <td>datetime</td> 
                    <td>null</td> 
                    <td>创建时间</td> 
                    <td>YES</td> 
                </tr> 
                </tbody> 
            </table> 
        </div> 
    </div> 
    <div class="tableInfo" id="oms_aftersale"> 
        <h1>表名：oms_aftersale</h1> 
        <div> 
            <h3>表的注释：</h3> 
            <pre>订单售后</pre> 
            <h3 class="backHome" onclick="backToHome()">返回目录</h3> 
            <table> 
                <thead> 
                    <th style="width:18%;">字段</th> 
                    <th style="width:8%;">类型</th> 
                    <th style="width:8%;">字段长度</th> 
                    <th style="width:60%;">注释</th> 
                    <th style="width:6%;">是否为空</th> 
                </thead> 
                <tbody> 
                <tr> 
                    <td>id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td></td> 
                    <td>NO</td> 
                </tr> 
                <tr> 
                    <td>member_id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td></td> 
                    <td>NO</td> 
                </tr> 
                <tr> 
                    <td>order_id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>订单id</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>return_amount</td> 
                    <td>decimal</td> 
                    <td>null</td> 
                    <td>退款金额</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>type</td> 
                    <td>int</td> 
                    <td>null</td> 
                    <td>售后类型：1：退款，2：退货退款</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>status</td> 
                    <td>int</td> 
                    <td>null</td> 
                    <td>申请状态：0->待处理；1->退货中；2->已完成；3->已拒绝</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>handle_time</td> 
                    <td>datetime</td> 
                    <td>null</td> 
                    <td>处理时间</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>quantity</td> 
                    <td>int</td> 
                    <td>null</td> 
                    <td>退货数量</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>reason</td> 
                    <td>varchar</td> 
                    <td>200</td> 
                    <td>原因</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>description</td> 
                    <td>varchar</td> 
                    <td>500</td> 
                    <td>描述</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>proof_pics</td> 
                    <td>varchar</td> 
                    <td>1000</td> 
                    <td>凭证图片，以逗号隔开</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>handle_note</td> 
                    <td>varchar</td> 
                    <td>500</td> 
                    <td>处理备注</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>handle_man</td> 
                    <td>varchar</td> 
                    <td>100</td> 
                    <td>处理人员</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>create_by</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>创建人</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>create_time</td> 
                    <td>datetime</td> 
                    <td>null</td> 
                    <td>创建时间</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>update_by</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>修改人</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>update_time</td> 
                    <td>datetime</td> 
                    <td>null</td> 
                    <td>修改时间</td> 
                    <td>YES</td> 
                </tr> 
                </tbody> 
            </table> 
        </div> 
    </div> 
    <div class="tableInfo" id="oms_aftersale_item"> 
        <h1>表名：oms_aftersale_item</h1> 
        <div> 
            <h3>表的注释：</h3> 
            <pre>订单售后</pre> 
            <h3 class="backHome" onclick="backToHome()">返回目录</h3> 
            <table> 
                <thead> 
                    <th style="width:18%;">字段</th> 
                    <th style="width:8%;">类型</th> 
                    <th style="width:8%;">字段长度</th> 
                    <th style="width:60%;">注释</th> 
                    <th style="width:6%;">是否为空</th> 
                </thead> 
                <tbody> 
                <tr> 
                    <td>id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td></td> 
                    <td>NO</td> 
                </tr> 
                <tr> 
                    <td>member_id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td></td> 
                    <td>NO</td> 
                </tr> 
                <tr> 
                    <td>aftersale_id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>售后单id</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>order_id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>订单id</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>order_item_id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>子订单id</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>return_amount</td> 
                    <td>decimal</td> 
                    <td>null</td> 
                    <td>退款金额</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>quantity</td> 
                    <td>int</td> 
                    <td>null</td> 
                    <td>退货数量</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>create_by</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>创建人</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>create_time</td> 
                    <td>datetime</td> 
                    <td>null</td> 
                    <td>创建时间</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>update_by</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>修改人</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>update_time</td> 
                    <td>datetime</td> 
                    <td>null</td> 
                    <td>修改时间</td> 
                    <td>YES</td> 
                </tr> 
                </tbody> 
            </table> 
        </div> 
    </div> 
    <div class="tableInfo" id="oms_order"> 
        <h1>表名：oms_order</h1> 
        <div> 
            <h3>表的注释：</h3> 
            <pre>订单表</pre> 
            <h3 class="backHome" onclick="backToHome()">返回目录</h3> 
            <table> 
                <thead> 
                    <th style="width:18%;">字段</th> 
                    <th style="width:8%;">类型</th> 
                    <th style="width:8%;">字段长度</th> 
                    <th style="width:60%;">注释</th> 
                    <th style="width:6%;">是否为空</th> 
                </thead> 
                <tbody> 
                <tr> 
                    <td>id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>订单id</td> 
                    <td>NO</td> 
                </tr> 
                <tr> 
                    <td>order_sn</td> 
                    <td>varchar</td> 
                    <td>32</td> 
                    <td>订单编号</td> 
                    <td>NO</td> 
                </tr> 
                <tr> 
                    <td>pay_id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>支付id</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>member_id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td></td> 
                    <td>NO</td> 
                </tr> 
                <tr> 
                    <td>member_username</td> 
                    <td>varchar</td> 
                    <td>64</td> 
                    <td>用户帐号</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>total_amount</td> 
                    <td>decimal</td> 
                    <td>null</td> 
                    <td>订单总金额</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>purchase_price</td> 
                    <td>decimal</td> 
                    <td>null</td> 
                    <td>采购价</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>pay_amount</td> 
                    <td>decimal</td> 
                    <td>null</td> 
                    <td>应付金额（实际支付金额）</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>freight_amount</td> 
                    <td>decimal</td> 
                    <td>null</td> 
                    <td>运费金额</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>pay_type</td> 
                    <td>int</td> 
                    <td>null</td> 
                    <td>支付方式：0->未支付；1->支付宝；2->微信</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>status</td> 
                    <td>int</td> 
                    <td>null</td> 
                    <td>订单状态：0->待付款；1->待发货；2->已发货；3->已完成；4->已关闭；5->无效订单</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>aftersale_status</td> 
                    <td>int</td> 
                    <td>null</td> 
                    <td>退款状态，枚举值：1：无售后或售后关闭，2：售后处理中，3：退款中，4： 退款成功</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>delivery_company</td> 
                    <td>varchar</td> 
                    <td>64</td> 
                    <td>物流公司(配送方式)</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>delivery_sn</td> 
                    <td>varchar</td> 
                    <td>64</td> 
                    <td>物流单号</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>auto_confirm_day</td> 
                    <td>int</td> 
                    <td>null</td> 
                    <td>自动确认时间（天）</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>receiver_name</td> 
                    <td>varchar</td> 
                    <td>100</td> 
                    <td>收货人姓名</td> 
                    <td>NO</td> 
                </tr> 
                <tr> 
                    <td>receiver_phone</td> 
                    <td>varchar</td> 
                    <td>32</td> 
                    <td>收货人电话</td> 
                    <td>NO</td> 
                </tr> 
                <tr> 
                    <td>receiver_post_code</td> 
                    <td>varchar</td> 
                    <td>32</td> 
                    <td>收货人邮编</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>receiver_province</td> 
                    <td>varchar</td> 
                    <td>32</td> 
                    <td>省份/直辖市</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>receiver_city</td> 
                    <td>varchar</td> 
                    <td>32</td> 
                    <td>城市</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>receiver_district</td> 
                    <td>varchar</td> 
                    <td>32</td> 
                    <td>区</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>receiver_province_id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>省份/直辖市id</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>receiver_city_id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>城市id</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>receiver_district_id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>区id</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>receiver_detail_address</td> 
                    <td>varchar</td> 
                    <td>200</td> 
                    <td>详细地址</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>note</td> 
                    <td>varchar</td> 
                    <td>500</td> 
                    <td>订单备注</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>merchant_note</td> 
                    <td>varchar</td> 
                    <td>500</td> 
                    <td>商家备注</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>confirm_status</td> 
                    <td>int</td> 
                    <td>null</td> 
                    <td>确认收货状态：0->未确认；1->已确认</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>delete_status</td> 
                    <td>bit</td> 
                    <td>null</td> 
                    <td>删除状态：0->未删除；1->已删除</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>payment_time</td> 
                    <td>datetime</td> 
                    <td>null</td> 
                    <td>支付时间</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>delivery_time</td> 
                    <td>datetime</td> 
                    <td>null</td> 
                    <td>发货时间</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>receive_time</td> 
                    <td>datetime</td> 
                    <td>null</td> 
                    <td>确认收货时间</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>create_by</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>创建人</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>create_time</td> 
                    <td>datetime</td> 
                    <td>null</td> 
                    <td>创建时间</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>update_by</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>修改人</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>update_time</td> 
                    <td>datetime</td> 
                    <td>null</td> 
                    <td>修改时间</td> 
                    <td>YES</td> 
                </tr> 
                </tbody> 
            </table> 
        </div> 
    </div> 
    <div class="tableInfo" id="oms_order_delivery_history"> 
        <h1>表名：oms_order_delivery_history</h1> 
        <div> 
            <h3>表的注释：</h3> 
            <pre>订单发货记录</pre> 
            <h3 class="backHome" onclick="backToHome()">返回目录</h3> 
            <table> 
                <thead> 
                    <th style="width:18%;">字段</th> 
                    <th style="width:8%;">类型</th> 
                    <th style="width:8%;">字段长度</th> 
                    <th style="width:60%;">注释</th> 
                    <th style="width:6%;">是否为空</th> 
                </thead> 
                <tbody> 
                <tr> 
                    <td>id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td></td> 
                    <td>NO</td> 
                </tr> 
                <tr> 
                    <td>order_id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>订单id</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>delivery_company</td> 
                    <td>varchar</td> 
                    <td>64</td> 
                    <td>物流公司(配送方式)</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>delivery_sn</td> 
                    <td>varchar</td> 
                    <td>64</td> 
                    <td>物流单号</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>create_by</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>创建人</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>create_time</td> 
                    <td>datetime</td> 
                    <td>null</td> 
                    <td>创建时间</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>update_by</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>修改人</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>update_time</td> 
                    <td>datetime</td> 
                    <td>null</td> 
                    <td>修改时间</td> 
                    <td>YES</td> 
                </tr> 
                </tbody> 
            </table> 
        </div> 
    </div> 
    <div class="tableInfo" id="oms_order_item"> 
        <h1>表名：oms_order_item</h1> 
        <div> 
            <h3>表的注释：</h3> 
            <pre>订单中所包含的商品</pre> 
            <h3 class="backHome" onclick="backToHome()">返回目录</h3> 
            <table> 
                <thead> 
                    <th style="width:18%;">字段</th> 
                    <th style="width:8%;">类型</th> 
                    <th style="width:8%;">字段长度</th> 
                    <th style="width:60%;">注释</th> 
                    <th style="width:6%;">是否为空</th> 
                </thead> 
                <tbody> 
                <tr> 
                    <td>id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td></td> 
                    <td>NO</td> 
                </tr> 
                <tr> 
                    <td>order_id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>订单id</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>product_id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td></td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>out_product_id</td> 
                    <td>varchar</td> 
                    <td>64</td> 
                    <td>商品编码</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>sku_id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>商品sku id</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>out_sku_id</td> 
                    <td>varchar</td> 
                    <td>64</td> 
                    <td>sku编码</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>product_snapshot_id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>商品快照id</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>sku_snapshot_id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>sku快照id</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>pic</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>展示图片</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>product_name</td> 
                    <td>varchar</td> 
                    <td>200</td> 
                    <td></td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>sale_price</td> 
                    <td>decimal</td> 
                    <td>null</td> 
                    <td>销售价格</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>purchase_price</td> 
                    <td>decimal</td> 
                    <td>null</td> 
                    <td>采购价</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>quantity</td> 
                    <td>int</td> 
                    <td>null</td> 
                    <td>购买数量</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>product_category_id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>商品分类id</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>sp_data</td> 
                    <td>varchar</td> 
                    <td>500</td> 
                    <td>商品sku属性:[{"key":"颜色","value":"颜色"},{"key":"容量","value":"4G"}]</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>create_by</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>创建人</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>create_time</td> 
                    <td>datetime</td> 
                    <td>null</td> 
                    <td>创建时间</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>update_by</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>修改人</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>update_time</td> 
                    <td>datetime</td> 
                    <td>null</td> 
                    <td>修改时间</td> 
                    <td>YES</td> 
                </tr> 
                </tbody> 
            </table> 
        </div> 
    </div> 
    <div class="tableInfo" id="oms_order_operate_history"> 
        <h1>表名：oms_order_operate_history</h1> 
        <div> 
            <h3>表的注释：</h3> 
            <pre>订单操作历史记录</pre> 
            <h3 class="backHome" onclick="backToHome()">返回目录</h3> 
            <table> 
                <thead> 
                    <th style="width:18%;">字段</th> 
                    <th style="width:8%;">类型</th> 
                    <th style="width:8%;">字段长度</th> 
                    <th style="width:60%;">注释</th> 
                    <th style="width:6%;">是否为空</th> 
                </thead> 
                <tbody> 
                <tr> 
                    <td>id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td></td> 
                    <td>NO</td> 
                </tr> 
                <tr> 
                    <td>order_id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>订单id</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>order_sn</td> 
                    <td>varchar</td> 
                    <td>32</td> 
                    <td>订单号</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>operate_man</td> 
                    <td>varchar</td> 
                    <td>100</td> 
                    <td>操作人：用户；系统；后台管理员</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>order_status</td> 
                    <td>int</td> 
                    <td>null</td> 
                    <td>订单状态：0->待付款；1->待发货；2->已发货；3->已完成；4->已关闭；5->无效订单 11->售后待处理；12->退货中；13->售后已完成；14->售后已拒绝</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>note</td> 
                    <td>varchar</td> 
                    <td>500</td> 
                    <td>备注</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>create_by</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>创建人</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>create_time</td> 
                    <td>datetime</td> 
                    <td>null</td> 
                    <td>创建时间</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>update_by</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>修改人</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>update_time</td> 
                    <td>datetime</td> 
                    <td>null</td> 
                    <td>修改时间</td> 
                    <td>YES</td> 
                </tr> 
                </tbody> 
            </table> 
        </div> 
    </div> 
    <div class="tableInfo" id="oms_wechat_payment_history"> 
        <h1>表名：oms_wechat_payment_history</h1> 
        <div> 
            <h3>表的注释：</h3> 
            <pre>微信订单表</pre> 
            <h3 class="backHome" onclick="backToHome()">返回目录</h3> 
            <table> 
                <thead> 
                    <th style="width:18%;">字段</th> 
                    <th style="width:8%;">类型</th> 
                    <th style="width:8%;">字段长度</th> 
                    <th style="width:60%;">注释</th> 
                    <th style="width:6%;">是否为空</th> 
                </thead> 
                <tbody> 
                <tr> 
                    <td>id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td></td> 
                    <td>NO</td> 
                </tr> 
                <tr> 
                    <td>payment_id</td> 
                    <td>varchar</td> 
                    <td>64</td> 
                    <td>payment_id</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>member_id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>用户 ID</td> 
                    <td>NO</td> 
                </tr> 
                <tr> 
                    <td>openid</td> 
                    <td>varchar</td> 
                    <td>64</td> 
                    <td>OPENID</td> 
                    <td>NO</td> 
                </tr> 
                <tr> 
                    <td>real_name</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>真实姓名，提现需要</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>title</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>标题|商品名称</td> 
                    <td>NO</td> 
                </tr> 
                <tr> 
                    <td>order_id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>订单号 支付时是payId 其他为orderId</td> 
                    <td>NO</td> 
                </tr> 
                <tr> 
                    <td>money</td> 
                    <td>decimal</td> 
                    <td>null</td> 
                    <td>金额，单位分</td> 
                    <td>NO</td> 
                </tr> 
                <tr> 
                    <td>op_type</td> 
                    <td>tinyint</td> 
                    <td>null</td> 
                    <td>交易类型（1为支付  2为提现  3为退款）</td> 
                    <td>NO</td> 
                </tr> 
                <tr> 
                    <td>payment_status</td> 
                    <td>tinyint</td> 
                    <td>null</td> 
                    <td>状态（0：未完成交易   1：完成关键交易）</td> 
                    <td>NO</td> 
                </tr> 
                <tr> 
                    <td>remark</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>备注</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>attach</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>附加数据</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>response_body</td> 
                    <td>text</td> 
                    <td>65535</td> 
                    <td>响应内容</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>create_by</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>创建人</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>create_time</td> 
                    <td>datetime</td> 
                    <td>null</td> 
                    <td>创建时间</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>update_by</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>修改人</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>update_time</td> 
                    <td>datetime</td> 
                    <td>null</td> 
                    <td>修改时间</td> 
                    <td>YES</td> 
                </tr> 
                </tbody> 
            </table> 
        </div> 
    </div> 
    <div class="tableInfo" id="p_brand"> 
        <h1>表名：p_brand</h1> 
        <div> 
            <h3>表的注释：</h3> 
            <pre>商品品牌信息表</pre> 
            <h3 class="backHome" onclick="backToHome()">返回目录</h3> 
            <table> 
                <thead> 
                    <th style="width:18%;">字段</th> 
                    <th style="width:8%;">类型</th> 
                    <th style="width:8%;">字段长度</th> 
                    <th style="width:60%;">注释</th> 
                    <th style="width:6%;">是否为空</th> 
                </thead> 
                <tbody> 
                <tr> 
                    <td>id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>id</td> 
                    <td>NO</td> 
                </tr> 
                <tr> 
                    <td>create_by</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>创建者</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>create_time</td> 
                    <td>datetime</td> 
                    <td>null</td> 
                    <td>创建时间</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>remark</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>备注</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>search_value</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>搜索值</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>tenant_id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>租户ID</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>update_by</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>更新者</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>update_time</td> 
                    <td>datetime</td> 
                    <td>null</td> 
                    <td>更新时间</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>big_pic</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>专区大图</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>brand_story</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>品牌故事</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>factory_status</td> 
                    <td>int</td> 
                    <td>null</td> 
                    <td>是否为品牌制造商：0->不是；1->是</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>first_letter</td> 
                    <td>varchar</td> 
                    <td>50</td> 
                    <td>品牌首字母</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>logo</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>品牌logo</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>name</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>品牌名称</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>product_comment_count</td> 
                    <td>int</td> 
                    <td>null</td> 
                    <td>产品评论数量</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>product_count</td> 
                    <td>int</td> 
                    <td>null</td> 
                    <td>产品数量</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>show_status</td> 
                    <td>int</td> 
                    <td>null</td> 
                    <td>显示状态：0->不显示；1->显示</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>sort</td> 
                    <td>int</td> 
                    <td>null</td> 
                    <td>排序</td> 
                    <td>YES</td> 
                </tr> 
                </tbody> 
            </table> 
        </div> 
    </div> 
    <div class="tableInfo" id="p_product"> 
        <h1>表名：p_product</h1> 
        <div> 
            <h3>表的注释：</h3> 
            <pre>商品信息表</pre> 
            <h3 class="backHome" onclick="backToHome()">返回目录</h3> 
            <table> 
                <thead> 
                    <th style="width:18%;">字段</th> 
                    <th style="width:8%;">类型</th> 
                    <th style="width:8%;">字段长度</th> 
                    <th style="width:60%;">注释</th> 
                    <th style="width:6%;">是否为空</th> 
                </thead> 
                <tbody> 
                <tr> 
                    <td>id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>id</td> 
                    <td>NO</td> 
                </tr> 
                <tr> 
                    <td>product_name</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>商品名称</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>product_category_id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>商品分类ID</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>product_category_name</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>商品分类名称</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>brand_name</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>品牌名称</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>original_price</td> 
                    <td>decimal</td> 
                    <td>null</td> 
                    <td>市场价</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>sell_price</td> 
                    <td>decimal</td> 
                    <td>null</td> 
                    <td>销售价格</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>unit</td> 
                    <td>varchar</td> 
                    <td>50</td> 
                    <td>单位</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>weight</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>商品重量</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>producing_area</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>产地</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>storage_method</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>储存方式</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>description</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>商品简介</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>specs</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>商品规格</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>picture</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>主图</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>album_pics</td> 
                    <td>varchar</td> 
                    <td>1000</td> 
                    <td>画册图片，以逗号分割</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>detail_picture</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>详情图</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>sort</td> 
                    <td>int</td> 
                    <td>null</td> 
                    <td>排序</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>create_by</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>创建者</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>create_time</td> 
                    <td>datetime</td> 
                    <td>null</td> 
                    <td>创建时间</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>delete_status</td> 
                    <td>int</td> 
                    <td>null</td> 
                    <td>删除状态：0->未删除；1->已删除</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>publish_status</td> 
                    <td>int</td> 
                    <td>null</td> 
                    <td>上架状态：0->下架；1->上架</td> 
                    <td>YES</td> 
                </tr> 
                </tbody> 
            </table> 
        </div> 
    </div> 
    <div class="tableInfo" id="p_product_attribute_key"> 
        <h1>表名：p_product_attribute_key</h1> 
        <div> 
            <h3>表的注释：</h3> 
            <pre>商品属性信息表</pre> 
            <h3 class="backHome" onclick="backToHome()">返回目录</h3> 
            <table> 
                <thead> 
                    <th style="width:18%;">字段</th> 
                    <th style="width:8%;">类型</th> 
                    <th style="width:8%;">字段长度</th> 
                    <th style="width:60%;">注释</th> 
                    <th style="width:6%;">是否为空</th> 
                </thead> 
                <tbody> 
                <tr> 
                    <td>id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>id</td> 
                    <td>NO</td> 
                </tr> 
                <tr> 
                    <td>product_id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>商品ID</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>attr_name</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>商品属性名称</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>attr_type</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>商品属性类别</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>create_by</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>创建者</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>create_time</td> 
                    <td>datetime</td> 
                    <td>null</td> 
                    <td>创建时间</td> 
                    <td>YES</td> 
                </tr> 
                </tbody> 
            </table> 
        </div> 
    </div> 
    <div class="tableInfo" id="p_product_attribute_sku"> 
        <h1>表名：p_product_attribute_sku</h1> 
        <div> 
            <h3>表的注释：</h3> 
            <pre>商品属性规格价格表</pre> 
            <h3 class="backHome" onclick="backToHome()">返回目录</h3> 
            <table> 
                <thead> 
                    <th style="width:18%;">字段</th> 
                    <th style="width:8%;">类型</th> 
                    <th style="width:8%;">字段长度</th> 
                    <th style="width:60%;">注释</th> 
                    <th style="width:6%;">是否为空</th> 
                </thead> 
                <tbody> 
                <tr> 
                    <td>id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>id</td> 
                    <td>NO</td> 
                </tr> 
                <tr> 
                    <td>product_id</td> 
                    <td>int</td> 
                    <td>null</td> 
                    <td>商品id</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>attr_symbol_path</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>属性搭配方式</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>original_price</td> 
                    <td>decimal</td> 
                    <td>null</td> 
                    <td>市场价</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>sell_price</td> 
                    <td>decimal</td> 
                    <td>null</td> 
                    <td>销售价</td> 
                    <td>YES</td> 
                </tr> 
                </tbody> 
            </table> 
        </div> 
    </div> 
    <div class="tableInfo" id="p_product_attribute_type"> 
        <h1>表名：p_product_attribute_type</h1> 
        <div> 
            <h3>表的注释：</h3> 
            <pre>商品属性类别</pre> 
            <h3 class="backHome" onclick="backToHome()">返回目录</h3> 
            <table> 
                <thead> 
                    <th style="width:18%;">字段</th> 
                    <th style="width:8%;">类型</th> 
                    <th style="width:8%;">字段长度</th> 
                    <th style="width:60%;">注释</th> 
                    <th style="width:6%;">是否为空</th> 
                </thead> 
                <tbody> 
                <tr> 
                    <td>id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>id</td> 
                    <td>NO</td> 
                </tr> 
                <tr> 
                    <td>typename</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>名称</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>create_by</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>创建者</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>create_time</td> 
                    <td>datetime</td> 
                    <td>null</td> 
                    <td>创建时间</td> 
                    <td>YES</td> 
                </tr> 
                </tbody> 
            </table> 
        </div> 
    </div> 
    <div class="tableInfo" id="p_product_attribute_value"> 
        <h1>表名：p_product_attribute_value</h1> 
        <div> 
            <h3>表的注释：</h3> 
            <pre>商品属性值信息表</pre> 
            <h3 class="backHome" onclick="backToHome()">返回目录</h3> 
            <table> 
                <thead> 
                    <th style="width:18%;">字段</th> 
                    <th style="width:8%;">类型</th> 
                    <th style="width:8%;">字段长度</th> 
                    <th style="width:60%;">注释</th> 
                    <th style="width:6%;">是否为空</th> 
                </thead> 
                <tbody> 
                <tr> 
                    <td>id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>id</td> 
                    <td>NO</td> 
                </tr> 
                <tr> 
                    <td>product_id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>商品ID</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>attr_key_id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>商品属性ID</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>attr_value</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>商品属性值</td> 
                    <td>YES</td> 
                </tr> 
                </tbody> 
            </table> 
        </div> 
    </div> 
    <div class="tableInfo" id="p_product_category"> 
        <h1>表名：p_product_category</h1> 
        <div> 
            <h3>表的注释：</h3> 
            <pre>商品分类信息表</pre> 
            <h3 class="backHome" onclick="backToHome()">返回目录</h3> 
            <table> 
                <thead> 
                    <th style="width:18%;">字段</th> 
                    <th style="width:8%;">类型</th> 
                    <th style="width:8%;">字段长度</th> 
                    <th style="width:60%;">注释</th> 
                    <th style="width:6%;">是否为空</th> 
                </thead> 
                <tbody> 
                <tr> 
                    <td>id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>id</td> 
                    <td>NO</td> 
                </tr> 
                <tr> 
                    <td>parent_id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>父级编号：0表示一级分类</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>name</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>分类名称</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>level</td> 
                    <td>int</td> 
                    <td>null</td> 
                    <td>分类级别：0->1级；1->2级</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>show_status</td> 
                    <td>int</td> 
                    <td>null</td> 
                    <td>显示状态：0->不显示；1->显示</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>icon</td> 
                    <td>varchar</td> 
                    <td>100</td> 
                    <td>图标</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>sort</td> 
                    <td>int</td> 
                    <td>null</td> 
                    <td>排序</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>create_by</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>创建者</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>create_time</td> 
                    <td>datetime</td> 
                    <td>null</td> 
                    <td>创建时间</td> 
                    <td>YES</td> 
                </tr> 
                </tbody> 
            </table> 
        </div> 
    </div> 
    <div class="tableInfo" id="p_product_member_price"> 
        <h1>表名：p_product_member_price</h1> 
        <div> 
            <h3>表的注释：</h3> 
            <pre>商品会员价格信息表</pre> 
            <h3 class="backHome" onclick="backToHome()">返回目录</h3> 
            <table> 
                <thead> 
                    <th style="width:18%;">字段</th> 
                    <th style="width:8%;">类型</th> 
                    <th style="width:8%;">字段长度</th> 
                    <th style="width:60%;">注释</th> 
                    <th style="width:6%;">是否为空</th> 
                </thead> 
                <tbody> 
                <tr> 
                    <td>id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>id</td> 
                    <td>NO</td> 
                </tr> 
                <tr> 
                    <td>create_by</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>创建者</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>create_time</td> 
                    <td>datetime</td> 
                    <td>null</td> 
                    <td>创建时间</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>remark</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>备注</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>search_value</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>搜索值</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>tenant_id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>租户ID</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>update_by</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>更新者</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>update_time</td> 
                    <td>datetime</td> 
                    <td>null</td> 
                    <td>更新时间</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>member_level_id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>会员等级ID</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>member_level_name</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>会员等级名称</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>member_price</td> 
                    <td>decimal</td> 
                    <td>null</td> 
                    <td>会员价格</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>product_id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>商品ID</td> 
                    <td>YES</td> 
                </tr> 
                </tbody> 
            </table> 
        </div> 
    </div> 
    <div class="tableInfo" id="p_product_sku_stock"> 
        <h1>表名：p_product_sku_stock</h1> 
        <div> 
            <h3>表的注释：</h3> 
            <pre>商品sku库存信息表</pre> 
            <h3 class="backHome" onclick="backToHome()">返回目录</h3> 
            <table> 
                <thead> 
                    <th style="width:18%;">字段</th> 
                    <th style="width:8%;">类型</th> 
                    <th style="width:8%;">字段长度</th> 
                    <th style="width:60%;">注释</th> 
                    <th style="width:6%;">是否为空</th> 
                </thead> 
                <tbody> 
                <tr> 
                    <td>id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>id</td> 
                    <td>NO</td> 
                </tr> 
                <tr> 
                    <td>create_by</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>创建者</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>create_time</td> 
                    <td>datetime</td> 
                    <td>null</td> 
                    <td>创建时间</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>remark</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>备注</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>search_value</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>搜索值</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>tenant_id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>租户ID</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>update_by</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>更新者</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>update_time</td> 
                    <td>datetime</td> 
                    <td>null</td> 
                    <td>更新时间</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>lock_stock</td> 
                    <td>decimal</td> 
                    <td>null</td> 
                    <td>锁定库存</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>low_stock</td> 
                    <td>decimal</td> 
                    <td>null</td> 
                    <td>预警库存</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>pic</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>展示图片</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>price</td> 
                    <td>decimal</td> 
                    <td>null</td> 
                    <td>价格</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>product_id</td> 
                    <td>bigint</td> 
                    <td>null</td> 
                    <td>商品ID</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>promotion_price</td> 
                    <td>decimal</td> 
                    <td>null</td> 
                    <td>单品促销价格</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>sale</td> 
                    <td>decimal</td> 
                    <td>null</td> 
                    <td>销量</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>sku_code</td> 
                    <td>varchar</td> 
                    <td>200</td> 
                    <td>sku编码</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>sp_data</td> 
                    <td>varchar</td> 
                    <td>255</td> 
                    <td>商品销售属性</td> 
                    <td>YES</td> 
                </tr> 
                <tr> 
                    <td>stock</td> 
                    <td>decimal</td> 
                    <td>null</td> 
                    <td>库存</td> 
                    <td>YES</td> 
                </tr> 
                </tbody> 
            </table> 
        </div> 
    </div> 
 
    <script> 
        var tableList = document.getElementsByClassName("tableList")[0]; 
        var tableInfos = document.getElementsByClassName("tableInfo"); 
        function queryInfo(tableName) { 
            tableList.style.display = "none"; 
            for (var i = 0; i <tableInfos.length ; i++) { 
                tableInfos[i].style.display = "none"; 
            } 
            document.getElementById(tableName).style.display="block"; 
            var trs = tableList.getElementsByTagName("tbody")[0].getElementsByTagName("tr"); 
            for (var i = 0; i <trs.length ; i++) { 
              if( trs[i].className == tableName ){ 
                trs[i].style.background = "pink"; 
              }else{ 
                trs[i].style.background = ""; 
              } 
            } 
        } 
        function backToHome() { 
            tableList.style.display = "block"; 
            for (var i = 0; i <tableInfos.length ; i++) { 
                tableInfos[i].style.display = "none"; 
            } 
        } 
    </script> 
 
</body> 
</html> 
 
